In the current era of global business where information and access reign supreme, the companies that are able to leverage their corporate data assets to the fullest are the companies where people flourish.

The Portland Data Management user group (DAMAPDX.org) is dedicated to delivering thought provoking, data-centric presentations that will make you more successful as a data professional. We are volunteer-run organization serving the local data community for over 10 years.

On 21Apr, our topic is the Data Management Maturity Model, featuring Melanie Mecca from CMMI. Registration is required. Visit damapdx.org for more information and to register.

The DMM model helps organizations become more proficient in managing critical data assets to improve operations, enable analytics and gain competitive advantage. The DMM model serves as a catalyst and a platform for the growth of a global community of professionals and practitioners who are committed to advancing the state of the practice.

The DMM model was developed using the principles and structure of CMMI Institute’s Capability Maturity Model Integration (CMMI) a proven approach to performance improvement and the gold standard for software and systems development for more than 20 years, originating in Carnegie Mellon University Software Engineering Institute.

Over the last two decades CMMI has been adopted in over 94 countries, applied in thousands of organizations, and has directly impacted the professional development of over 150,000 people.

About The Speaker

Melanie Mecca is the CMMI Institute’s Program Manager for the Data Management Maturity (DMM) Model, and a primary author of the DMM since January 2011.

She has led DMM Assessments for the Securities and Exchange Commission, the Office of Financial Research, Microsoft Corporation, Fannie Mae, the Federal Reserve System Statistics Function, the Ontario Teachers’ Pension Plan and Freddie Mac.

She has architected and implemented data strategies and organization-wide data management improvement programs, and managed programs and projects to design: enterprise data architectures, master data hubs, data warehouse components, and shared data services.

Schedule

• 8:00 - 8:30 am - Sign In
• 8:30 - 9:45 am - Presentation
• 9:45 - 10:00 am - Break, Chapter Announcements
• 10:00 - 11:00 am - Presentation continued

• Free for members!
• $15 for guests
• See damapdx.org for the list of our corporate members

There is now a second bonus data presentation at this month's Data Management chapter meeting. First, Information Quality (IQ scoring) followed by an Introduction to storing time-series data in Round Robin Databases. Join us for now two presentations designed to make you more productive in your data career.

For more information and to register, visit damapdx.org

Session 1 - Information Quality Scoring

IQScoring is an assessment methodology CQN is using across the company to help communicate the IQ state of key enterprise datasets and applications. It produces a simple metric that is easy to communicate to business stakeholders and management in a consistent way, encouraging IQ conversations where frequently overlooked or excluded. This technique can be a valuable tool in the hands of Data Scientists, Analysts, and Business Decision-Makers.

About the Speaker

Rodney Schackmann joined Intel in 1993, with time in IT and business groups, he joined CQN in 2010 where he is currently a Sr. Staff Information Architect.

He is a frequent presenter at Information / Data Quality and Data Governance related conferences. His history includes software development, management, consulting, mentoring, and strategic technical leadership.

His time at Intel has primarily been focused on Key Information efforts — driving cross-organizational teams to better solutions with higher Information Quality results. Rodney currently runs the enterprise-wide Information Quality program for CQN.

Session 2 - An Introduction to Round Robin Databases

As technology professionals, we see a increasing applications for telemetry, systems monitoring, and real-time trend analysis. In some situations, unbounded storage of collected measurements may be impractical or unnecessary. Round Robin Databases are designed to store and maintain multiple time-series archives at varying resolutions. They employ methods that allow the storage of months or even years of data.

We will explore one such tool, RRDtool, a project started at the Center for Applied Internet Data Analysis. At first, this open source tool helped with collecting and reporting on internet traffic. Since that time, it has inspired many other uses and tools. Our goal is to explore the retention decisions, downsampling of data consistent with it's business value, and how this approach is good for solving a specific class of problems.

About the Speaker

Chris Irvine is currently a Technology Consultant and founder at Threeprong.com, specializing in custom workgroup solutions, B2B integration, and performance tuning. He is a computer science graduate of Portland State University with professional experience in software development, system administration, and IT management.

Chris takes pleasure in applying technology to help solve problems for a variety of businesses and non-profits. Recent projects meet the needs of small business, workgroups in large enterprise, and also for government, in many segments and varied platforms.

Schedule

• 8:30 - 9:00 am - Sign In
• 9:00 - 10:15 am - Presentation
• 10:15 - 10:30 am - Break, Chapter Announcements
• 10:30 - 11:30 am - Presentation continued

Our chapter meetings have a nominal cost to cover refreshments and speaker expenses.

• Free for Members!
• $15 for Non-Members
• $5 for Students with valid student ID
• View the list of corporate members at damapdx.org

The Portland Metro Chapter of the Data Administration Management Association has been serving the Portland data community since 1984. We are a not-for-profit, vendor independent, professional association dedicated to advancing the concepts and practices of enterprise information and data resource management.

Our primary purpose is to promote the understanding, development and practice of managing data, information and knowledge resources as key enterprise assets.

DAMA-Portland Metro members and attendees enjoy the opportunity to hear industry leading professionals present on relevant topics and the most current technologies and methodologies of the day.

Prior presentations and speakers for this year (2016):

• January: "Framing Business Problems as Data Mining Problems" with Asoka Diggs (Intel)

Upcoming Presentation & Speakers for 2016:

• February: "Information Quality (IQ Scoring)" with Rodney Schackmann (Intel) at The Standard
• March: "Advanced Data Visualization" with Michael Scofield (Loma Linda University) at The Standard
• April: "The Vital Role Data Managers in E –Discovery and Information Governance" with Mike Hamilton & Nancy Patton (Exterro) at Cambia/Regence
• May: "Agile Development and Data Management" with Michele Goetz (Forrester Research) at The Standard

Want to take your career to the next level?

Practical, Hands-on Training for Advanced Excel Formulas & Functions

Microsoft Excel is perhaps the most important computer software program used in business today. That's why so many workers and prospective employees are required to learn Excel to enter or remain in the workplace. Unfortunately many college students, recent grads, and professionals haven’t mastered Excel or have the adequate Excel skills employers are seeking. According to Payscale, “ 80 percent of job openings require spreadsheet and word-processing software skills. Yet so many people never even give Excel a chance because it has an intimidating stigma around it.”

If you walk through the finance or accounting department at any major corporate office, you will see computer screens filled with Excel spreadsheets outlining financial results, budgets, forecasts, and plans used to make big business decisions. Marketing and Product profesionals using Excel to list customer and sales targets; managing thier sales force and planning future marketing plans based on past results. Pivot tables to quickly and easily summarize customer and sales data by category with a quick drag-and drop. HR professionals using giant spreadsheets full of employee data and understand exactly where the costs are coming from and how to best plan and control them for the future. Supply logistic professional to manage inventory and forecasts demand.In essence, you can turn an entire department around just because you know how to manipulate data in order to get an aggregate view.

STRUCTURE OF COURSE

Advanced functions and formulas

 *Logical functions
 *Conditional functions
 *Financial functions
 *Text functions
 *Date functions
 *Array formulas

Lookups and data tables

 *Using lookup functions
 *Using MATCH and INDEX
 *Creating data tables

Advanced data management

 *Validating cell entries
 *Advanced filtering

Advanced charting

 *Chart formatting options
 *Combination charts
 *Graphical objects

PivotTables and PivotCharts

 *Working with PivotTables
 *Rearranging PivotTables
 *Formatting PivotTables
 *PivotCharts

Exporting and Importing Data

 *Exporting and importing text files
 *Getting external data

Analytical Tools

 *Goal Seek
 *Scenarios

Macros and Visual Basic

 *Running and recording a macro
 *Working with VBA code

ABOUT THE INSTRUCTOR

Martin Jetton has 30+ years of advanced supply chain analytics, predictive analytics, and statistical consulting experience. He's currently a Principal at the Liberty Advisor Group, where he works in advanced supply chain analytics. In his previous role, he was the Senior Predictive Consultant at Corios; where he developed predictive models and scorecards, forecast trends, identify uncertainties, and assign the ideal strategies to maximize performance. The firm’s clients are in the banking, brokerage, credit, utilities and healthcare industries.

BENEFITS

Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

MAKE YOUR RESUME STAND OUT

They are NOT seeing if you simply have Excel as a skill. They are diving deeping when it comes to determining which candidate to interview and hire. They look for Pivot Table, VLOOKUP, Macros, VBA, Conditional Formatting, Charting and Filtering…These are far more telling of your ability to an employer then writing Excel. Someone who writes VLOOKUP, Pivot Table, Filtering demonstrates an ability to analyse data and so has eliminated a potential barrier in the mind of the hiring manager reviewing your resume. In essence, use actual Excel functions in your Resume!

INCREASE YOUR EARNING POTENTIAL

Did you know that Excel know-how can instantly increase your job prospects as well as your starting salary? Excel is a transferrable skill that any hiring manager understands is critical. Research shows job applicants who know MS Excel make $22.66 per hour on average compared to the $20.14 per hour their peers make who don’t know the program. That’s roughly an extra $20 per eight-hour workday and $100 per work week, simply for knowing how to use a single computer program. Moreover, full-time employees in certain industries can see a starting salary bump of anywhere from $1,000 to $7,000 per year based on their Excel skills. That’s not chump change you can ignore.

INSPIRING ENTREPRENEUR?

A majority 63 percent of twenty-somethings want to start their own business. How will you stay organized, track data, or forecast your finances if you’re not spreadsheet-savvy? Many millennials simply want their first job. But, what about your performance once someone hires you? The biggest complaint employers have about millennials is that they lack basic hard and soft skills.These skills include things like teamwork and problem solving, but also basic administrative skills like MS Word and Powerpoint. Once you’re hired, you want to meet the basic requirements of your role without stressing.

WHO SHOULD COME?

People whose work is completed through MS Excel; Software Engineers, Finance Professionals, HR Professionals, Marketing Professionals, Project Managers, Technology Professionals.

ADDITIONAL BENEFITS?

FOR FURTHER INFORMATION: PLEASE CONTACT US AT [email protected].

SOLD OUT?

This is one of our high demand classes. In the case, we sale out; email us at [email protected] and ask when our next course will be in

Data Science Is the Future of Everything

Predictive Modeling and Analytics with R

Join us for our Predictive Modeling and Analytics workshop on Saturday, November 10th, 2018; featuring Martin Jetton, with 30+ years of advanced supply chain analytics, predictive analytics, and statistical consulting experience. In his previous role, he was the Senior Predictive Consultant at Corios; where he developed predictive models and scorecards, forecast trends, identify uncertainties, and assign the ideal strategies to maximize performance.

The world has now turned into a digital workspace. Online activity and real-world sensors are generating torrents of data about everything from weather to crime to our buying habits. Increasing computer power and new analytical techniques promise to turn masses of raw data into actionable intelligence—and thereby transform a variety of industries and propel us to a data-driven economy. According to analysts, the Data Analytics market will be almost $50B by 2020. Coupled with the estimation that by 2019 there will nearly 1.2 million open data jobs with no one to fill them, it is clear that understanding and communicating with data will be critical for impact. The skills needed to be a Business Analyst, Data Analyst, or Data Scientist are all about to be in real demand, and our trainings with experience Data Science Practitioners will help you get head start! (International Data Corporation).

HOW COMPANIES ARE USING R?

Facebook - For behavior analysis related to status updates and profile pictures. Google - For advertising effectiveness and economic forecasting. Twitter - For data visualization and semantic clustering Microsoft - Acquired Revolution R company and use it for a variety of purposes. Xbox uses R for a great gaming experience. Uber - For statistical analysis Airbnb - Scale data science. IBM - To help create IBM Watson, an open, cognitive computing technology platform that represents a new era in computing where systems understand the world like humans do: through senses, learning, and experience.

This course will introduce you to some of the most widely used predictive modeling techniques and their core principles. By taking this course, you will form a solid foundation of predictive analytics, which refers to tools and techniques for building statistical or machine learning models to make predictions based on data. You will learn how to carry out exploratory data analysis to gain insights and prepare data for predictive modeling, an essential skill valued in the business.

WHY R PROGRAMMING FOR PREDICTIVE ANALYTICS?

R is a programming language originally written for statisticians to do statistical analysis, including predictive analytics. It’s open-source software, used extensively in academia to teach such disciplines as statistics, bioinformatics, and economics. From its humble beginnings, it has since been extended to do data modeling, data mining, and predictive analysis.

ABOUT THE INSTRUCTOR

Martin Jetton has 30+ years of advanced supply chain analytics, predictive analytics, and statistical consulting experience. He's currently a Principal at the Liberty Advisor Group, where he works in advanced supply chain analytics. In his previous role, he was the Senior Predictive Consultant at Corios; where he developed predictive models and scorecards, forecast trends, identify uncertainties, and assign the ideal strategies to maximize performance. The firm’s clients are in the banking, brokerage, credit, utilities and healthcare industries.

SOLD OUT?

This is one of our high demand classes. In the case, we sale out; email us at [email protected] and ask when our next course will be in.